<?php

$installer = $this;

$installer->startSetup();

$installer->run("
-- DROP TABLE IF EXISTS {$this->getTable('bundlepromotion')};
CREATE TABLE {$this->getTable('bundlepromotion')} (
  `bundlepromotion_id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '', 
  `simple_action` varchar(255) NOT NULL default '', 
  `discount_amount` decimal(12,4)  null, 
  `product_ids` varchar(255) NOT NULL default '',
  `models` varchar(255) NOT NULL default '',  
  `customer_group_ids` varchar(255) NOT NULL default '', 
  `rule_id` int(11)  NOT NULL default 0, 
  `coupon_code` varchar(255) NOT NULL default '', 
  `status` smallint(6) NOT NULL default '0',
  `created_time` datetime NULL,
  `update_time` datetime NULL,
  PRIMARY KEY (`bundlepromotion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");

$installer->endSetup(); 